SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE  VIEW [dbo].[TMEMPR] AS   
SELECT CO_EMPR,  
DE_NOMB,  
DE_NOMB_CORT,  
CO_GIRO,  
DE_DIRE,  
CO_UBIC_GEOG,  
CO_PAIS,  
NO_DEPA,  
NO_PROV,  
DE_CODI_POST,  
NU_TLF1,  
NU_TLF2,  
NU_FAXS,  
NU_RUCS,  
DE_DIRE_WEBS,  
DE_DIRE_MAIL,  
CO_MONE_NACI,  
NU_CERT_INSC,  
NU_REGI_PUBL,  
NU_LICE_MUNI,  
NO_REPR_LEGA,  
NO_GERE_GRAL,  
ST_PLAN,  
ST_CONT,  
ST_TESO,  
ST_LOGI,  
ST_VENT,  
ST_PROD,  
ST_ACTI,  
ST_PRES,  
ST_SIS1,  
ST_SIS2,  
ST_SIS3,  
ST_SIS4,  
ST_SIS5,  
NV_INFO_OSER,  
NV_QUIE_OSER,  
DE_RUTA_LOGO,  
TI_SITU,  
CO_REGI_LABO,  
CO_USUA_CREA,  
FE_USUA_CREA,  
CO_USUA_MODI,  
FE_USUA_MODI,  
--DE_LOGO,  
TI_DOID_GERE,  
TI_DOID_REPR,  
FE_INSC,  
NU_DOID_REPR,  
NU_DOID_GERE 
FROM OFISEGU..TMEMPR  

GO
